/****** Object:  Stored Procedure ResponsibleOfficesDelete    Script Date: Monday, November 26, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spResponsibleOfficesDeleteByConPoint]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spResponsibleOfficesDeleteByConPoint]
GO


CREATE PROCEDURE spResponsibleOfficesDeleteByConPoint
	@ConPointID int
AS

DELETE FROM
[ResponsibleOffices]
WHERE @ConPointID IN (SELECT Responsibles.ConPointID FROM Responsibles WHERE [ResponsibleOffices].[ResponsibleID] = Responsibles.[ResponsibleID])

GO
	
	

	
 